package com.haust.mapper;

import com.haust.pojo.TbItemParamItem;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ItemParamItemMapper {
    @Select("SELECT paramItem.id,paramItem.item_id,paramItem.param_data,paramItem.created,paramItem.updated" +
            " FROM tb_item_param_item paramItem LEFT JOIN tb_item item on paramItem.item_id=item.id" +
            " WHERE paramItem.item_id=#{param1} and item.status=#{param2}")
    TbItemParamItem selectOneTbItemParamItem4Status1(Long id, Integer status);
}
